Commands

Description

Sample

getsysdate (1-13)

get system date

getsysdate 9

put fieldname

put data to this field

put date

focus fieldname

cursor will go to this field

focus fullname

get fieldname

get data from this field

get fullname

clearpage

clear all fields data

clearpage

clear fieldname1 fieldname2

clear named fields data

clear fullname date

resetcc

disable query save when no data is entered

resetcc

combinetext fieldname+"_"+fieldname

combine text from the named fields

combinetext date+"_"+fullname

newrcd

clear all fields and start a new record

newrcd

getrcd

select a record from the default database

getrcd

imporcd *.xdb

import a record from the *.xdb file

imporcd address_book.xdb

impoasc ascfilename

import a record from the specified ASCII (text) file

impoasc -d catalog.icf

opendv *.xdb

open DataView window with *xdb database file

opendv address_book.xdb

dv_sfudif fieldname

open DataView window filter by fieldname data

dv_sfudif category

dv_showflds fieldname

open DataView window display fieldname field

dv_showflds category item

openfile *.pf

open *.pf file

openfile address_book.pf

goto *.pf

close current file and go to *.pf file

goto address_book.pf

savercd

save record

savrcd

close

the current form

close

print

the current form

print

url fieldname

open the url in the field

url website

removebl

remove the blank line

repl fieldname

replace data in this field

repl salestax

punt -file[*.pf]

import the current record into the target file

punt -file[sales.pf]

push button_name

execute commands set in this button

push btn_1

eval

calculate the equation

eval (#taxrate/100.00) * (#subtotal +#freight )

seldate -field[fieldname]

select date, put to fieldname

seldate -field[date]

seltime -field[fieldname]

select time, put to fieldname

seldate -field[time]

createrp

to preview the page, same as File/Preview As Report

cam -field[fieldname]

open Cam dialog box to take a picture and put in the field

cam -field[photo]